# import  pymysql
# #连接到mysql数据库
# conn = pymysql.connect(user = "root",password="123456",database="bookms_hw_test")
# creat_table = '''CREATE TABLE BookMS (
#     bid INT AUTO_INCREMENT,
#     name VARCHAR(255)  ,
#     price float  ,
#     summary VARCHAR(255) ,
#     PRIMARY KEY (bid)
# );
# '''
#
# cursor = conn.cursor()
# cursor.execute(creat_table)
# conn.commit()
# cursor.close()
# conn.close()